USE NHOMMUA

SET DATEFORMAT dmy
GO
SET ANSI_WARNINGS OFF
GO

SET IDENTITY_INSERT [ACCOUNT] ON

GO

INSERT [ACCOUNT] ([IDACCOUNT], [VISIBLE], [ACCOUNT_STYLE], [USERNAME], [PASSWORD], [FULLNAME], [EMAIL], [ADDRESS], [PHONE_NUMBER], [CMND])
	VALUES (1, 1, 1, 'admin', '123456', N'Trần Văn Thành', 'toisekhongyeu.tran@gmail.com', N'Ninh Bình', '01662924099', '164481463')
GO

INSERT [ACCOUNT] ([IDACCOUNT], [VISIBLE], [ACCOUNT_STYLE], [USERNAME], [PASSWORD], [FULLNAME], [EMAIL], [ADDRESS], [PHONE_NUMBER], [CMND])
	VALUES (2, 1, 1, 'manager', '123456', N'Trần Văn Thành', 'toisekhongyeu.tran@gmail.com', N'Ninh Bình', '01662924099', '164481463')
GO

INSERT [ACCOUNT] ([IDACCOUNT], [VISIBLE], [ACCOUNT_STYLE], [USERNAME], [PASSWORD], [FULLNAME], [EMAIL], [ADDRESS], [PHONE_NUMBER], [CMND])
	VALUES (3, 1, 0, 'provider', '123456', N'Nguyễn Đăng Thành', 'nguyendangthanh@yahoo.com.vn', N'Huế', '0987878123', '98730295')
GO

INSERT [ACCOUNT] ([IDACCOUNT], [VISIBLE], [ACCOUNT_STYLE], [USERNAME], [PASSWORD], [FULLNAME], [EMAIL], [ADDRESS], [PHONE_NUMBER], [CMND])
	VALUES (4, 1, 0, 'doanhnghiep', '123456', N'Nguyễn Phước Thành', 'nptcntt@gmail.com', N'Bà Rịa Vũng Tàu', '098367462', '4598449732')
GO

INSERT [ACCOUNT] ([IDACCOUNT], [VISIBLE], [ACCOUNT_STYLE], [USERNAME], [PASSWORD], [FULLNAME], [EMAIL], [ADDRESS], [PHONE_NUMBER], [CMND])
	VALUES (5, 1, 1, 'user', '123456', N'Liễu Quang Tín', 'lieuquangtin@yahoo.com', N'Hồ Chí Minh', '08473662726', '294738347')
GO

INSERT [ACCOUNT] ([IDACCOUNT], [VISIBLE], [ACCOUNT_STYLE], [USERNAME], [PASSWORD], [FULLNAME], [EMAIL], [ADDRESS], [PHONE_NUMBER], [CMND])
	VALUES (6, 1, 1, 'nguoidung', '123456', N'Nguyễn Xuân Toàn', 'nxtoan7@gmail.com', N'Hồ Chí Minh', '43354564656', '434354553')
GO

SET IDENTITY_INSERT [ACCOUNT] OFF

GO

